package com.zhu.gmallpublisher.mapper;

import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.math.BigDecimal;

/**
 * 用户交易总额数据层
 */

//@Repository
public interface GMVMapper {

    /**
     * 查询订单总额
     * @param selectDate 日期
     * @return
     */
    @Select("select sum(order_amount) from dws_trade_province_order_window where toYYYYMMDD(stt)=#{selectDate}")
    Double selectGMV(int selectDate);
}
